from sqlalchemy import Column, Integer, String, Boolean, DateTime, text

from datetime import datetime
from config.Database import Base

class SubmitInfo(Base):
    __tablename__ = "submitinfo"

    id = Column(Integer, primary_key=True, autoincrement=True)
    nickName = Column(String(10))
    username = Column(String(255))
    password = Column(String(255))
    email = Column(String(255))
    ids = Column(String(255))
    activityName = Column(String(50))
    isPush = Column(Boolean, default=False)
    isDelete = Column(Boolean, default=False)
    isSuccess = Column(Boolean, default=False)
    remark = Column(String(255))
    applyAt = Column(DateTime)
    createAt = Column(DateTime, server_default=text('CURRENT_TIMESTAMP'))
